﻿/****** Object:  Table [dbo].[S_actionlog]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_actionlog](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[AppName] [nvarchar](20) NULL,
	[UserId] [int] NULL,
	[Action] [ntext] NULL,
	[FullUrl] [ntext] NULL,
	[Define1] [ntext] NULL,
	[Define2] [ntext] NULL,
	[Define3] [ntext] NULL,
	[Description] [ntext] NULL,
	[RequestInfo] [ntext] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](50) NULL,
 CONSTRAINT [PK_S_actionlog] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_department]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_department](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Deptcode] [nvarchar](20) NULL,
	[Deptname] [nvarchar](100) NULL,
	[Depttype] [nvarchar](50) NULL,
	[Leader] [nvarchar](50) NULL,
	[Tel] [nvarchar](50) NULL,
	[Remark] [nvarchar](100) NULL,
	[Isauthorize] [nchar](1) NULL,
	[Isdeleted] [nchar](1) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_department] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_dict]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_dict](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Typecode] [nvarchar](20) NOT NULL,
	[Sort] [int] NOT NULL,
	[Code] [nvarchar](20) NOT NULL,
	[Name_cn] [nvarchar](100) NOT NULL,
	[Name_hk] [nvarchar](100) NULL,
	[Name_en] [nvarchar](100) NULL,
	[Value1] [nvarchar](100) NULL,
	[Value2] [nvarchar](100) NULL,
	[Value3] [nvarchar](100) NULL,
	[Remark] [nvarchar](100) NULL,
	[Isdeleted] [nchar](1) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_dict] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_dicttype]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_dicttype](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Typecode] [nvarchar](20) NOT NULL,
	[Typename_cn] [nvarchar](50) NOT NULL,
	[Typename_en] [nvarchar](50) NULL,
	[Sort] [int] NULL,
	[Isvalid] [nchar](1) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_dicttype] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_document]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_document](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SiteId] [int] NOT NULL,
	[DocKey] [nvarchar](50) NULL,
	[Category] [nvarchar](50) NULL,
	[Title] [nvarchar](100) NULL,
	[TitleHK] [nvarchar](100) NULL,
	[Content] [ntext] NULL,
	[ContentHK] [ntext] NULL,
	[Attachurl] [nvarchar](200) NULL,
	[Remark] [nvarchar](100) NULL,
	[Isdeleted] [int] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_document] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_environment]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_environment](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Parametername] [nvarchar](50) NOT NULL,
	[Parametervalue] [nvarchar](200) NULL,
	[Remark] [ntext] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_environment] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_gridcolumn]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_gridcolumn](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Userid] [int] NOT NULL,
	[Pagekey] [nvarchar](100) NULL,
	[Sort] [int] NOT NULL,
	[Field] [nvarchar](100) NULL,
	[Title] [nvarchar](100) NULL,
	[Title_en] [nvarchar](100) NULL,
	[TitleReskey] [nvarchar](100) NULL,
	[Width] [nvarchar](20) NULL,
	[Align] [nvarchar](20) NULL,
	[Hidden] [int] NOT NULL,
	[Sortable] [int] NOT NULL,
	[Islist] [int] NOT NULL,
	[Isexport] [int] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_gridcolumn] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_lang_res]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_lang_res](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Lang] [nvarchar](50) NOT NULL,
	[Resname] [nvarchar](200) NULL,
	[Rescategory] [nvarchar](50) NOT NULL,
	[Reskey] [nvarchar](200) NOT NULL,
	[Rescontent] [ntext] NOT NULL,
	[Resjs] [smallint] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_lang_res] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_menu]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_menu](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Menukind] [nvarchar](50) NOT NULL,
	[Menuid] [nvarchar](50) NOT NULL,
	[Menuname_zho] [nvarchar](50) NOT NULL,
	[Menuname_eng] [nvarchar](50) NULL,
	[Pmenuid] [nvarchar](50) NULL,
	[Islastlevel] [int] NOT NULL,
	[Orderseq] [nvarchar](10) NULL,
	[Menuactions] [int] NOT NULL,
	[Showallways] [int] NOT NULL,
	[Menuobject] [nvarchar](100) NULL,
	[Menuurl] [nvarchar](100) NULL,
	[Menuparams] [nvarchar](100) NULL,
	[Menuiconsmall] [nvarchar](100) NULL,
	[Menuiconmiddle] [nvarchar](100) NULL,
	[Menuiconlarge] [nvarchar](100) NULL,
	[Iscontextmenu] [int] NOT NULL,
	[Istoolbarmenu] [int] NOT NULL,
	[Isshortcutmenu] [int] NOT NULL,
	[Showtopsep] [int] NOT NULL,
	[Showbottomsep] [int] NOT NULL,
	[Tag_1] [nvarchar](100) NULL,
	[Tag_2] [nvarchar](100) NULL,
	[Tag_3] [nvarchar](100) NULL,
	[Tag_4] [nvarchar](100) NULL,
	[Tag_5] [nvarchar](100) NULL,
	[Status] [int] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](50) NULL,
	[Updateip] [nvarchar](50) NULL,
 CONSTRAINT [PK_S_menu] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_role]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_role](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Roleid] [nvarchar](30) NULL,
	[Roletype] [nvarchar](20) NULL,
	[Rolename] [nvarchar](50) NULL,
	[Description] [nvarchar](100) NULL,
	[Remark] [nvarchar](100) NULL,
	[Isdeleted] [nchar](1) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_role] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_role_menu]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_role_menu](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Roleid] [nvarchar](30) NULL,
	[Menuid] [nvarchar](50) NULL,
	[Userpower] [nvarchar](50) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_role_menu] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_sequence]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_sequence](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Seqtype] [nvarchar](50) NOT NULL,
	[Currentval] [int] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_sequence] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_smS_template]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_smS_template](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Smskey] [nvarchar](50) NOT NULL,
	[Smscontent] [ntext] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_smS_template] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_smS_validcode]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_smS_validcode](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Source] [nvarchar](500) NOT NULL,
	[Senduser] [nvarchar](50) NULL,
	[Keycode] [nvarchar](50) NOT NULL,
	[Mobilenum] [nvarchar](20) NULL,
	[Validatetype] [nvarchar](50) NOT NULL,
	[Validatecode] [nvarchar](10) NOT NULL,
	[Expiretime] [datetime] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_smS_validcode] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_smslog]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_smslog](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Source] [ntext] NOT NULL,
	[Sendto] [nvarchar](20) NOT NULL,
	[Senduser] [nvarchar](50) NULL,
	[Smstype] [nvarchar](50) NOT NULL,
	[Smscontent] [ntext] NOT NULL,
	[Status] [nvarchar](20) NOT NULL,
	[Comments] [ntext] NULL,
	[Isdeleted] [nchar](1) NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_smslog] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_sysdict]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_sysdict](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Typecode] [nvarchar](20) NOT NULL,
	[Sort] [int] NOT NULL,
	[Code] [nvarchar](20) NOT NULL,
	[Name_cn] [nvarchar](100) NOT NULL,
	[Name_hk] [nvarchar](100) NULL,
	[Name_en] [nvarchar](100) NULL,
	[Value1] [nvarchar](100) NULL,
	[Value2] [nvarchar](100) NULL,
	[Value3] [nvarchar](100) NULL,
	[Remark] [nvarchar](100) NULL,
	[Isdeleted] [nchar](1) NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_sysdict] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_sysdicttype]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_sysdicttype](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Typecode] [nvarchar](20) NOT NULL,
	[Typename_cn] [nvarchar](50) NOT NULL,
	[Typename_en] [nvarchar](50) NULL,
	[Sort] [int] NULL,
	[Isvalid] [nchar](1) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_sysdicttype] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_syslog]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_syslog](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[User_id] [int] NULL,
	[Username] [nvarchar](50) NULL,
	[Menuid] [nvarchar](20) NULL,
	[Menuname] [nvarchar](50) NULL,
	[Oprttype] [int] NULL,
	[Oprttime] [datetime] NULL,
	[Ip] [nvarchar](50) NULL,
	[Ip_2] [nvarchar](50) NULL,
	[Macaddr] [nvarchar](50) NULL,
	[Comments] [ntext] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_syslog] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_user]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_user](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Username] [nvarchar](50) NOT NULL,
	[Realname] [nvarchar](50) NULL,
	[Usertype] [nvarchar](50) NOT NULL,
	[Dept_id] [int] NULL,
	[Password] [nvarchar](200) NOT NULL,
	[Sex] [nvarchar](10) NULL,
	[Tel] [nvarchar](20) NULL,
	[Mobile] [nvarchar](20) NULL,
	[Email] [nvarchar](100) NULL,
	[Province] [nvarchar](50) NULL,
	[City] [nvarchar](50) NULL,
	[District] [nvarchar](50) NULL,
	[Address] [nvarchar](100) NULL,
	[Islocked] [nchar](1) NOT NULL,
	[Ischangepwd] [nchar](1) NOT NULL,
	[Remark] [nvarchar](100) NULL,
	[Isdeleted] [nchar](1) NOT NULL,
	[Registertime] [datetime] NULL,
	[Lastlogintime] [datetime] NULL,
	[Lastloginip] [nvarchar](50) NULL,
	[Logintimes] [int] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
	[Clientid] [nvarchar](50) NULL,
 CONSTRAINT [PK_S_user] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_user_log]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_user_log](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[User_id] [int] NOT NULL,
	[Username] [nvarchar](50) NULL,
	[Devicetype] [nvarchar](50) NULL,
	[Oprttype] [int] NOT NULL,
	[Oprttime] [datetime] NOT NULL,
	[Ipaddress] [nvarchar](50) NULL,
	[Comments] [nvarchar](500) NULL,
 CONSTRAINT [PK_S_user_log] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_user_loginerror]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_user_loginerror](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[User_id] [int] NOT NULL,
	[Username] [nvarchar](50) NULL,
	[Oprttype] [int] NOT NULL,
	[Oprttime] [datetime] NULL,
	[Clientid] [nvarchar](50) NULL,
	[Ip] [nvarchar](50) NULL,
	[Comments] [ntext] NULL,
	[Errortimes] [int] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_user_loginerror] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_user_role]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_user_role](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[User_id] [int] NULL,
	[Roleid] [nvarchar](30) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [nvarchar](256) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [nvarchar](256) NULL,
 CONSTRAINT [PK_S_user_role] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_user_token]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_user_token](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[User_id] [int] NOT NULL,
	[Devicetype] [nvarchar](50) NULL,
	[Deviceid] [nvarchar](50) NULL,
	[Token] [nvarchar](50) NOT NULL,
	[Createtime] [datetime] NOT NULL,
	[Expiration] [datetime] NULL,
 CONSTRAINT [PK_S_user_token] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[S_user_validatenum]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[S_user_validatenum](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Deviceid] [nvarchar](50) NULL,
	[Devicetype] [nvarchar](50) NULL,
	[Username] [nvarchar](50) NULL,
	[Mobilenum] [nvarchar](50) NULL,
	[Validatetype] [nvarchar](50) NULL,
	[Validatenum] [nvarchar](20) NULL,
	[Createtime] [datetime] NOT NULL,
	[Expiretime] [datetime] NULL,
	[Sessionid] [nvarchar](50) NULL,
 CONSTRAINT [PK_S_user_validatenum] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[T_detectiondata]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_detectiondata](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Lmttype] [nvarchar](50) NOT NULL,
	[Lmtnumber] [nvarchar](50) NOT NULL,
	[Repairchar] [nvarchar](50) NULL,
	[Repairstartdate] [datetime] NULL,
	[Parttype] [nvarchar](50) NULL,
	[Workdate] [datetime] NULL,
	[Detectiontype] [nvarchar](50) NULL,
	[Devicenames] [nvarchar](500) NULL,
	[Temperature] [decimal](18, 0) NULL,
	[Humidity] [decimal](18, 0) NULL,
	[Workuser] [nvarchar](50) NULL,
	[Workleader] [nvarchar](50) NULL,
	[Checkuser] [nvarchar](50) NULL,
	[Checktime] [datetime] NULL,
	[Status] [nvarchar](50) NULL,
	[Remark] [nvarchar](200) NULL,
	[Isdeleted] [int] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_detectiondata] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_detectiondata_device]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_detectiondata_device](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Detectiondata_id] [int] NOT NULL,
	[Device_id] [int] NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_detectiondata_device] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_detectiondata_dtl]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_detectiondata_dtl](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Detectiondata_id] [int] NOT NULL,
	[Wheelno] [int] NOT NULL,
	[Wheelcode] [nvarchar](50) NULL,
	[Partname] [nvarchar](50) NULL,
	[Partcode] [nvarchar](50) NULL,
	[Workresult] [nvarchar](500) NULL,
	[Proposal] [nvarchar](500) NULL,
	[Imageurl] [nvarchar](200) NULL,
	[Workuser] [nvarchar](50) NULL,
	[Workleader] [nvarchar](50) NULL,
	[Workdate] [datetime] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_detectiondata_dtl] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_detectiondata_report]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_detectiondata_report](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Detectiondata_id] [int] NOT NULL,
	[Partname] [nvarchar](50) NOT NULL,
	[Reporttitle] [nvarchar](200) NOT NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_detectiondata_report] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_device]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_device](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Devicetype] [nvarchar](50) NULL,
	[Devicemodel] [nvarchar](50) NULL,
	[Devicename] [nvarchar](100) NOT NULL,
	[Devicecode] [nvarchar](20) NULL,
	[Madedate] [datetime] NULL,
	[Checkdate] [datetime] NULL,
	[Status] [varchar](20) NULL,
	[Remark] [nvarchar](200) NULL,
	[Isdeleted] [int] NOT NULL DEFAULT ((0)),
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_device] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_lmtwheel]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_lmtwheel](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Lmttype] [nvarchar](50) NOT NULL,
	[Lmtnumber] [nvarchar](50) NOT NULL,
	[Installdate] [datetime] NULL,
	[Wheelno] [int] NOT NULL,
	[Wheelcode] [varchar](50) NOT NULL,
	[Madedate] [datetime] NULL,
	[Repairdate] [datetime] NULL,
	[Tmms_l] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_lmtwheel_Tmms_l]  DEFAULT ((0)),
	[Tmms_r] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_lmtwheel_Tmms_r]  DEFAULT ((0)),
	[Lyhd_l] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_lmtwheel_Lyhd_l]  DEFAULT ((0)),
	[Lyhd_r] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_lmtwheel_Lyhd_r]  DEFAULT ((0)),
	[Ldzj_l] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_lmtwheel_Ldzj_l]  DEFAULT ((0)),
	[Ldzj_r] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_lmtwheel_Ldzj_r]  DEFAULT ((0)),
	[Ncjl] [decimal](18, 2) NOT NULL,
	[Remark] [nvarchar](200) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_lmtwheel] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_lmtwheel_log]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_lmtwheel_log](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Lmttype] [nvarchar](50) NOT NULL,
	[Lmtnumber] [nvarchar](50) NOT NULL,
	[Logtype] [nvarchar](50) NOT NULL,
	[Logdate] [datetime] NOT NULL,
	[Wheelno] [int] NOT NULL,
	[Wheelcode] [varchar](50) NOT NULL,
	[Reason] [nvarchar](1000) NULL,
	[Workname] [nvarchar](1000) NULL,
	[Repairkm] [decimal](18, 2) NULL,
	[Madedate] [datetime] NULL,
	[Remark] [nvarchar](200) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_lmtwheel_log] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_partname]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_partname](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Lmttype] [nvarchar](50) NULL,
	[Parttype] [nvarchar](50) NOT NULL,
	[Sort] [int] NOT NULL DEFAULT ((0)),
	[Partname] [nvarchar](50) NOT NULL,
	[Remark] [nvarchar](200) NULL,
	[Isdeleted] [int] NOT NULL DEFAULT ((0)),
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_partname] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_wheel_repairplan]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_wheel_repairplan](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Lmttype] [nvarchar](50) NOT NULL,
	[Lmtnumber] [nvarchar](50) NOT NULL,
	[Plandate] [datetime] NOT NULL,
	[Planuser] [nvarchar](50) NULL,
	[Status] [nvarchar](50) NULL,
	[Remark] [nvarchar](200) NULL,
	[Isdeleted] [int] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_wheel_repairplan] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_wheel_repairplan_dtl]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_wheel_repairplan_dtl](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Repairplan_id] [int] NOT NULL,
	[Wheelno] [int] NULL,
	[Wheelcode] [nvarchar](50) NULL,
	[Wheeldirection] [nvarchar](10) NULL,
	[Ldzj_org] [decimal](18, 2) NULL,
	[Ldzj_plan] [varchar](50) NULL,
	[Tmms_org] [decimal](18, 2) NULL,
	[Tmms_plan] [varchar](50) NULL,
	[Lyhd_org] [decimal](18, 2) NULL,
	[Lyhd_plan] [varchar](50) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_wheel_repairplan_dtl] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_wheel_repairplan_result]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_wheel_repairplan_result](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Repairplan_id] [int] NOT NULL,
	[Wheelno] [int] NULL,
	[Wheelcode] [nvarchar](50) NULL,
	[Wheeldirection] [nvarchar](10) NULL,
	[Ldzj_org] [decimal](18, 2) NULL,
	[Ldzj_result] [varchar](50) NULL,
	[Tmms_org] [decimal](18, 2) NULL,
	[Tmms_result] [varchar](50) NULL,
	[Lyhd_org] [decimal](18, 2) NULL,
	[Lyhd_result] [varchar](50) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_wheel_repairplan_result] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_wheeldata]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_wheeldata](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Lmttype] [nvarchar](50) NOT NULL,
	[Lmtnumber] [nvarchar](50) NOT NULL,
	[Repairchar] [nvarchar](50) NULL,
	[Repairstartdate] [datetime] NULL,
	[Repairkm] [decimal](18, 0) NULL,
	[Sheettype] [nvarchar](100) NULL,
	[Workdate] [datetime] NULL,
	[Workuser] [nvarchar](50) NULL,
	[Workleader] [nvarchar](50) NULL,
	[Checkuser] [nvarchar](50) NULL,
	[Checktime] [datetime] NULL,
	[Status] [nvarchar](50) NULL,
	[Remark] [nvarchar](200) NULL,
	[Isdeleted] [int] NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_wheeldata] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_wheeldata_cggddtl]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_wheeldata_cggddtl](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Wheeldata_id] [int] NULL,
	[Cggdgap] [decimal](18, 2) NULL,
	[Cggdgapresult] [nvarchar](50) NULL,
	[Cggdfront] [decimal](18, 2) NULL,
	[Cggdfrontresult] [nvarchar](50) NULL,
	[Cggdback] [decimal](18, 2) NULL,
	[Cggdbackresult] [nvarchar](50) NULL,
	[Remark] [nvarchar](200) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
	[Workdate] [datetime] NULL,
	[Adjusttype] [nvarchar](20) NULL,
 CONSTRAINT [PK_T_wheeldata_cggddtl] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_wheeldata_cgkddtl]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_wheeldata_cgkddtl](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Wheeldata_id] [int] NULL,
	[Cgbswkdfront] [nvarchar](50) NULL,
	[Cgkswkdfront] [nvarchar](50) NULL,
	[Ftjxfront] [nvarchar](50) NULL,
	[Cgbswkdback] [nvarchar](50) NULL,
	[Cgkswkdback] [nvarchar](50) NULL,
	[Ftjxback] [nvarchar](50) NULL,
	[Remark] [nvarchar](200) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_wheeldata_cgkddtl] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_wheeldata_lddtl]    Script Date: 2017/5/4 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_wheeldata_lddtl](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Wheeldata_id] [int] NULL,
	[Wheelno] [int] NULL,
	[Wheelcode] [nvarchar](50) NULL,
	[Wheeldirection] [nvarchar](10) NULL,
	[Tmmsx1] [decimal](18, 2) NULL,
	[Tmmsx2] [decimal](18, 2) NULL,
	[Tmmsx3] [decimal](18, 2) NULL,
	[Tmmsavg] [decimal](18, 2) NULL,
	[Tmmsresult] [nvarchar](50) NULL,
	[Lyhdx1] [decimal](18, 2) NULL,
	[Lyhdx2] [decimal](18, 2) NULL,
	[Lyhdx3] [decimal](18, 2) NULL,
	[Lyhdavg] [decimal](18, 2) NULL,
	[Lyhdresult] [nvarchar](50) NULL,
	[Ncjlx1] [decimal](18, 2) NULL,
	[Ncjlx2] [decimal](18, 2) NULL,
	[Ncjlx3] [decimal](18, 2) NULL,
	[Ncjlavg] [decimal](18, 2) NULL,
	[Ncjlresult] [nvarchar](50) NULL,
	[Ldzjx1] [decimal](18, 2) NULL,
	[Ldzjx2] [decimal](18, 2) NULL,
	[Ldzjx3] [decimal](18, 2) NULL,
	[Ldzjavg] [decimal](18, 2) NULL,
	[Ldzjresult] [nvarchar](50) NULL,
	[Remark] [nvarchar](200) NULL,
	[Createtime] [datetime] NULL,
	[Createuser] [varchar](50) NULL,
	[Updatetime] [datetime] NULL,
	[Updateuser] [varchar](50) NULL,
 CONSTRAINT [PK_T_wheeldata_lddtl] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_T_detectiondata]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_detectiondata] ON [dbo].[T_detectiondata]
(
	[Lmttype] ASC,
	[Lmtnumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_T_detectiondata_device]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_detectiondata_device] ON [dbo].[T_detectiondata_device]
(
	[Detectiondata_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_T_detectiondata_dtl]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_detectiondata_dtl] ON [dbo].[T_detectiondata_dtl]
(
	[Detectiondata_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_T_detectiondata_report]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_detectiondata_report] ON [dbo].[T_detectiondata_report]
(
	[Detectiondata_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_T_lmtwheel]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_lmtwheel] ON [dbo].[T_lmtwheel]
(
	[Lmttype] ASC,
	[Lmtnumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_T_lmtwheel_log]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_lmtwheel_log] ON [dbo].[T_lmtwheel_log]
(
	[Lmttype] ASC,
	[Lmtnumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_T_partname]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_partname] ON [dbo].[T_partname]
(
	[Lmttype] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_T_wheeldata]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_wheeldata] ON [dbo].[T_wheeldata]
(
	[Lmttype] ASC,
	[Lmtnumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_T_wheeldata_cggddtl]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_wheeldata_cggddtl] ON [dbo].[T_wheeldata_cggddtl]
(
	[Wheeldata_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_T_wheeldata_cgkddtl]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_wheeldata_cgkddtl] ON [dbo].[T_wheeldata_cgkddtl]
(
	[Wheeldata_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_T_wheeldata_lddtl]    Script Date: 2017/5/4 10:33:43 ******/
CREATE NONCLUSTERED INDEX [IX_T_wheeldata_lddtl] ON [dbo].[T_wheeldata_lddtl]
(
	[Wheeldata_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Lmttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Lmtnumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前修程' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Repairchar'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检修开始日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Repairstartdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤部件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Parttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Workdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检测方法' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Detectiontype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检测仪器' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Devicenames'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'温度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'湿度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Humidity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Workuser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Workleader'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验收人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Checkuser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验收时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Checktime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'逻辑删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata', @level2type=N'COLUMN',@level2name=N'Isdeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_device', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤记录Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_device', @level2type=N'COLUMN',@level2name=N'Detectiondata_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检测仪器Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_device', @level2type=N'COLUMN',@level2name=N'Device_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤记录Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Detectiondata_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轴号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Wheelno'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车轴编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Wheelcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Partname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部件编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Partcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤结果' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Workresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'处理意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Proposal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图示url' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Imageurl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Workuser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复检人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Workleader'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_dtl', @level2type=N'COLUMN',@level2name=N'Workdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_report', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤记录Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_report', @level2type=N'COLUMN',@level2name=N'Detectiondata_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_report', @level2type=N'COLUMN',@level2name=N'Partname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检测项目' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_detectiondata_report', @level2type=N'COLUMN',@level2name=N'Reporttitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Devicetype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备型号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Devicemodel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Devicename'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Devicecode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Madedate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上次检测日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Checkdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'逻辑删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_device', @level2type=N'COLUMN',@level2name=N'Isdeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Lmttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Lmtnumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'装车日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Installdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轴号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Wheelno'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车轴编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Wheelcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出厂日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Madedate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上次检修时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Repairdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨损' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Tmms_l'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨损' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Tmms_r'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Lyhd_l'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Lyhd_r'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Ldzj_l'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Ldzj_r'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对内侧距离' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Ncjl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Lmttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Lmtnumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Logtype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Logdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轴号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Wheelno'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车轴编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Wheelcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检修原因' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Reason'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检修内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Workname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'走行公里' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Repairkm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出厂日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Madedate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_lmtwheel_log', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_partname', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_partname', @level2type=N'COLUMN',@level2name=N'Lmttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'探伤分类' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_partname', @level2type=N'COLUMN',@level2name=N'Parttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_partname', @level2type=N'COLUMN',@level2name=N'Sort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_partname', @level2type=N'COLUMN',@level2name=N'Partname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_partname', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'逻辑删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_partname', @level2type=N'COLUMN',@level2name=N'Isdeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Lmttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Lmtnumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'计划日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Plandate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'计划制定人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Planuser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'逻辑删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan', @level2type=N'COLUMN',@level2name=N'Isdeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'计划Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Repairplan_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轴号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Wheelno'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车轴编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Wheelcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'左/右' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Wheeldirection'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径原数据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Ldzj_org'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径控制数据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Ldzj_plan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨耗原数据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Tmms_org'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨耗控制数据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Tmms_plan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度原数据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Lyhd_org'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度控制数据' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_dtl', @level2type=N'COLUMN',@level2name=N'Lyhd_plan'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'计划Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Repairplan_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轴号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Wheelno'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车轴编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Wheelcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'左/右' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Wheeldirection'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径旋轮前' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Ldzj_org'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径旋轮后' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Ldzj_result'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨耗旋轮前' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Tmms_org'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨耗旋轮后' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Tmms_result'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度旋轮前' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Lyhd_org'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度旋轮后' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheel_repairplan_result', @level2type=N'COLUMN',@level2name=N'Lyhd_result'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Lmttype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Lmtnumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前修程' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Repairchar'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检修开始日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Repairstartdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运行里程' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Repairkm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测量表分类' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Sheettype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测量日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Workdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测量人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Workuser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复检人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Workleader'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验收人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Checkuser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验收时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Checktime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'逻辑删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata', @level2type=N'COLUMN',@level2name=N'Isdeleted'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测量记录Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Wheeldata_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车钩高度差(mm)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Cggdgap'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车钩高度是否超限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Cggdgapresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前车钩高度(mm)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Cggdfront'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'前车钩高度是否超限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Cggdfrontresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'后车钩高度(mm)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Cggdback'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'后车钩高度是否超限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Cggdbackresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cggddtl', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测量记录Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Wheeldata_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车钩闭锁位开度(前)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Cgbswkdfront'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车钩开锁位开度(前)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Cgkswkdfront'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'防跳性能(前)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Ftjxfront'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车钩闭锁位开度(后)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Cgbswkdback'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车钩开锁位开度(后)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Cgkswkdback'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'防跳间隙(后)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Ftjxback'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_cgkddtl', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测量记录Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Wheeldata_id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轴号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Wheelno'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'车轴编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Wheelcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'左/右' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Wheeldirection'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨损X1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Tmmsx1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨损X2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Tmmsx2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨损X3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Tmmsx3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨损均值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Tmmsavg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'踏面磨损结论' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Tmmsresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度X1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Lyhdx1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度X2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Lyhdx2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度X3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Lyhdx3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度均值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Lyhdavg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮缘厚度结论' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Lyhdresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对内侧距离X1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ncjlx1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对内侧距离X2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ncjlx2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对内侧距离X3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ncjlx3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对内侧距离均值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ncjlavg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对内侧距离结论' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ncjlresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径X1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ldzjx1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径X2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ldzjx2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径X3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ldzjx3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径均值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ldzjavg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'轮对直径结论' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Ldzjresult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_wheeldata_lddtl', @level2type=N'COLUMN',@level2name=N'Remark'
GO
